SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 680718 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 680718 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283072,352427,605650,403485,214925,661057,679349,588291,649228,148413,907429,849217,192831,688286,623539,302306,226966,849679,444089,243904,143785,742786,802255,257497,226317,154303,777320,400705,1038938,520116,514520,659829,474818,696897,747076,455938,864649,1014793,379001,828530,178492,966229,151927,318784,638948,680268,126422,478880,1045383,524645,727418,356315,527085,867383,938268,62792,716607,719107,291342,753536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 680718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 680718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]