SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327814 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327814 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527339,400666,1016384,803879,682972,547299,1033006,624932,74453,639448,365382,387195,1006265,192323,38085,40825,762965,359948,245760,380860,982464,623883,942653,361189,445041,181107,697863,3206,410955,647158,413321,368998,684472,544673,901697,655871,658813,370213,362892,234590,199497,174948,454355,406348,914312,132128,391139,409955,671760,595954,1013604,773581,681895,25326,857216,440752,384186,864259,486068,896258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002237s ]