SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 275940 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 275940 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785804,501677,633361,213269,57191,272857,367182,801883,986124,981896,460416,683465,173791,542555,866988,33028,269948,606364,781428,107869,877010,810092,24936,941942,789917,269641,951883,432858,582399,767666,378833,124301,235616,348285,544147,851499,736392,198838,88558,659613,443310,930530,959161,1048268,817399,875499,854447,952841,211999,720543,188814,189433,1032315,479135,231774,651268,850749,432670,569318,671107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 275940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 275940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]