SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428255 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428255 [ RunTime:0.001392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510793,720980,58263,352151,377661,401967,370094,1046370,684225,286299,1020011,410054,903827,1033464,324894,551676,820603,1040801,53123,564402,926199,557050,182050,264843,184750,881092,187135,129649,487490,802078,777047,394014,725653,234366,756103,1011885,28577,1010890,273785,434894,881132,891154,309014,550820,311162,96316,407110,632995,1000018,336191,305594,354781,786221,843732,305052,516836,9518,610252,824880,14397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428255 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428255 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]