SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002748s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563343 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563343 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001306,396137,485011,166336,382750,602861,569056,209662,774344,402882,454232,1004532,483051,60145,45114,165384,567025,534545,325480,156889,163644,215925,823149,183731,678378,343280,788842,445441,8035,797282,71407,809843,1037936,21880,11751,449248,751029,552935,637675,756846,703645,295617,178997,500627,108031,317181,505133,1035384,928603,415349,1045627,225873,3221,564971,678684,204564,666376,367986,201722,784531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]