SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447181 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447181 [ RunTime:0.002622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522434,577954,9966,423036,1038093,31855,194489,800650,479914,449227,875262,114287,485537,111247,324580,957717,334998,145433,881984,911711,223064,376469,985873,667210,447264,1024637,512979,785558,203616,920269,1003286,249046,122196,648432,201166,846503,312406,666502,1043321,697814,510371,1028755,160436,31108,165923,835719,77527,210545,1017453,270076,457778,265778,865814,122194,412012,323282,995500,399583,837988,841732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]