SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310606 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310606 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105144,838601,195610,504901,368802,831437,924025,1032562,558834,120642,81329,326401,184298,885438,446588,871170,564569,107186,430688,397969,886737,149523,769485,374496,769448,371561,963360,624066,905306,842979,1019851,27050,787963,348470,815201,227016,390367,302733,730455,970216,353354,178868,920485,120553,921523,41736,60683,842027,171072,524029,553276,263345,899003,561035,442713,877664,291173,877419,223459,447570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]