SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593814 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593814 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641363,1027635,495229,594898,1024487,1015571,837617,582531,875515,190009,505001,985972,382946,955793,550600,924612,112389,975015,658434,985949,540984,677188,100107,427295,344463,478763,425739,429942,183613,11625,1033647,559444,477970,193973,266055,1047793,920036,282116,864486,243169,506136,495638,837344,208719,838490,242793,429519,1014427,508231,732963,904136,68981,798296,270514,200216,452620,467632,603577,95134,743505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]