SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342706 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342706 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452079,511377,839239,986297,638118,52011,890604,715190,131106,991095,689969,318417,929265,434918,910406,228619,171904,601788,408373,268194,1036817,104396,679427,522017,771635,932310,930913,175323,938516,556469,214956,21074,330352,279781,123522,900775,399614,702990,1002339,43173,12607,20187,1018755,964193,7479,515253,528119,928857,133129,644880,324691,947353,1004477,267120,404438,449902,270099,975350,75668,750689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]