SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396626 LIMIT 1 [ RunTime:0.000835s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396626 [ RunTime:0.003392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501074,586139,286203,210996,224216,522395,211186,313435,836323,251111,559213,976655,474861,15876,351074,996116,455903,697801,510288,424531,176483,541024,693748,117295,101138,1018560,835404,1034251,94792,788173,876642,122503,393011,852883,379163,79156,225891,804613,546095,577326,461344,130694,489159,353328,501462,388800,862751,734091,738540,1038058,27016,539280,1016534,523490,92681,954143,652765,33241,653588,762946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]