SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447743 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447743 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864289,1013941,115814,932828,842886,181779,853102,237919,511440,822138,93862,1009170,633538,40160,63513,536554,442041,1031953,1019800,412552,539451,782642,991280,831291,757076,963367,71586,213406,1006906,712337,99678,138824,645549,818656,218860,683173,678928,757114,736591,156573,279675,362796,805647,497665,253763,248228,146449,790774,1029832,21481,857695,970650,242236,212811,3959,332149,667883,182884,939553,952013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000783s ]