SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547329 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547329 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524471,1047305,590533,821970,501945,269846,132561,359880,979640,421378,491858,59766,98049,472967,701841,33133,130428,109950,458402,678640,652614,797563,1009286,94641,621752,102386,706260,880380,245499,494089,386763,249760,733397,833016,37167,63671,757096,528863,924229,145074,343805,291600,34101,447699,922634,403719,884281,590960,1031769,407368,348763,514566,563672,610946,54177,386559,920236,29709,523208,382081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]