SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 612564 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 612564 [ RunTime:0.004580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481287,820318,459008,852415,165732,778271,922529,195213,394055,309143,35626,442244,736876,743766,427933,172295,389073,125278,1040701,1016330,112945,147526,542720,730510,734662,8558,578775,619629,183379,717730,405591,299570,990159,909290,295678,1014280,791561,68438,599006,772077,1008608,408965,175471,204151,336163,134619,754400,274864,499947,507107,593165,104975,49994,878914,696054,468743,653406,794187,951937,397880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 612564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 612564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]