SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540854 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540854 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419652,494927,702168,430473,553834,717031,392225,922154,735542,692260,566768,118007,148959,868184,59655,638494,514907,825446,929400,846848,797021,95272,86359,364547,808790,351515,405651,540872,89483,651901,867687,493851,454357,18311,754790,373972,567875,660438,933595,958148,408333,503512,905778,692153,335381,549299,688543,29845,292264,877498,394991,102471,609204,837311,14210,680849,117910,554071,445977,585965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]