SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469025 LIMIT 1 [ RunTime:0.002586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469025 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17740,718365,631436,480735,160912,990640,793754,242178,270588,95950,169608,899074,641468,47566,512613,610062,267039,375692,126029,990411,109935,354328,1021135,406339,362232,510972,875697,187900,354137,134268,960655,758061,556392,586123,850856,722374,759554,599624,98505,699774,660522,161409,342874,70375,652835,792920,828882,743798,887257,934140,809436,1036059,387168,568181,171994,129912,69999,140406,103958,564089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]