SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 640190 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 640190 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013881,403890,1039732,706588,926026,371012,460395,739381,709405,36053,99211,154060,12678,205712,712953,247267,176708,942940,516359,11472,307344,547578,311784,278937,476579,399110,72768,490919,257203,196070,312803,234623,945083,484523,859198,587450,403856,822143,35071,767104,278080,914922,875540,379180,61081,750963,860907,996664,489618,143681,839032,345341,170755,594297,560994,132476,826878,899857,265456,994533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 640190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 640190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]