SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001995s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 964833 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 964833 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500011,436929,648735,416330,477412,814420,686253,142516,125527,52407,973676,590850,387655,794835,559155,451000,881549,404168,476986,491469,532747,801851,307549,219515,60860,181410,728260,93959,853857,684660,145496,553103,356126,346212,200460,370095,565472,94808,462209,305060,278107,74266,450922,342924,404260,1038954,229882,943947,1023304,942301,485116,881362,413343,45000,414487,493693,291814,905588,166421,928178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 964833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 964833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]