SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019628 LIMIT 1 [ RunTime:0.001163s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019628 [ RunTime:0.003244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235552,142368,962945,164218,751141,451683,312931,770692,70627,859480,450500,717833,201839,1024681,273292,168844,384099,711038,273704,94709,291985,834107,726664,201643,30569,406130,870181,516373,389261,144839,573089,491650,542351,1000000,1032106,168808,454344,154095,272115,33423,198740,749948,842667,879282,1038378,867798,421089,98135,731473,787641,976043,184279,819636,986106,334190,541716,778894,716713,1030915,337111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002996s ]