SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002909s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045213 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045213 [ RunTime:0.003738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514563,667323,507014,205026,852747,66,451728,1012364,934923,565560,448450,266706,569140,585530,534423,496838,16718,426856,662759,848113,68166,491346,86850,297595,844348,448448,111693,213592,190464,136359,289909,274801,305216,786741,882508,781418,103999,506987,491246,492985,888873,951789,397402,934073,543847,958128,900258,785925,136215,781270,761131,244192,158786,284610,884453,676863,461889,66817,953523,118033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003783s ]