SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543359 LIMIT 1 [ RunTime:0.003572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543359 [ RunTime:0.004135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550628,328142,464954,1023878,881279,791353,382668,965340,756606,212178,497817,957786,1016702,198571,893490,200337,596393,715888,987979,655138,821525,628208,283466,1040806,822528,875226,549363,281550,6172,689667,801924,47572,914934,149768,946957,14404,649528,784403,73702,840007,306867,194343,345590,360319,471041,981526,1004837,828507,232792,836459,415731,802861,903421,179719,168741,1048552,405867,170457,146993,164217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543359 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543359 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]