SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803404 LIMIT 1 [ RunTime:0.001047s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803404 [ RunTime:0.002518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187133,331126,843334,411249,651139,714485,233326,153503,859686,892024,289989,467251,12204,385372,391788,873866,17501,945343,516272,324831,305078,840488,113312,443724,341911,341071,967419,615984,693104,480158,953684,599884,124776,316993,207799,665527,735252,150564,1002176,919527,748776,47289,411884,765324,6725,152071,638283,469983,1042514,14221,520619,446886,889408,81849,1043406,353303,332734,687223,416541,1048634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006782s ]