SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 862308 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 862308 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956958,967126,492028,774965,11093,1015993,441820,981238,667071,925744,214277,223532,511490,497354,1025587,402117,27790,456021,237511,665407,435697,990040,771378,747845,934843,883103,729885,914902,874756,611376,1048012,120249,614928,244544,519556,52679,655700,562844,727212,535168,653463,704082,443917,736817,400774,393800,937594,96763,870608,293876,159278,94612,742980,1003199,427299,759672,518534,744403,435405,220295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 862308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 862308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]