SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295271 LIMIT 1 [ RunTime:0.000824s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295271 [ RunTime:0.004701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883107,875565,723187,148131,747332,1046286,939696,580939,405273,451322,575348,75501,140480,148370,437742,832125,86260,70181,966878,774556,196786,367260,896817,90255,631559,398326,442111,328468,865096,100448,877877,208190,476785,885489,156361,112160,959205,305179,935511,392637,73300,109448,866187,1018075,423435,814851,90087,658393,779167,178878,221196,288236,518305,436519,729860,454656,196094,557571,920016,100562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000919s ]