SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341200 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341200 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98392,983914,19275,648944,822170,348898,495158,813613,604362,814294,741065,905905,308847,307323,142103,997778,487580,393998,863344,661820,103010,986649,500356,603424,664294,899501,973851,517950,478867,256852,323120,497738,520104,383155,55840,204354,544551,211211,359296,649070,611757,1039794,1014590,344482,940891,259778,107370,708910,600975,551575,717966,375539,702673,940227,586669,772050,30569,803618,298584,85773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]