SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249836 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249836 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986987,492924,320658,102869,275919,64763,744205,289143,993890,262631,73412,556352,812645,318433,448057,886896,290135,206460,200807,882850,722261,350092,350620,74424,113397,323820,975066,522169,820737,819196,637482,637781,158814,1042093,1036391,872314,441796,753093,584571,468197,912180,680577,146701,957987,752475,669144,202468,592926,703464,720283,35584,374756,469257,1024048,362078,504648,805284,899660,380024,564991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001121s ]