SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353417 LIMIT 1 [ RunTime:0.000783s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353417 [ RunTime:0.002660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538984,618312,866325,458141,958433,710052,780246,47332,95249,210130,370725,590476,801488,259171,631774,737154,729582,792218,505798,883322,987790,948247,1022008,12484,753188,549173,648876,765831,1010879,500997,611489,76620,357043,580640,95212,71572,339642,984468,347043,668706,287450,26078,146915,367890,453605,88782,202451,355866,921696,866358,844989,987874,942496,237558,924801,897866,796162,1041363,170085,95362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]