SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480190 LIMIT 1 [ RunTime:0.001223s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480190 [ RunTime:0.008477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703721,505747,523217,831249,541614,219518,232980,329724,246645,503346,953883,533399,233328,701912,554358,552611,510377,975300,123368,767330,892632,536700,530367,568164,608953,166849,384351,310584,312435,681048,281830,888665,947638,888850,497351,518795,322076,713277,78199,524313,452467,551755,514684,556343,600606,343587,696902,833480,633457,785600,964317,244902,190420,1014165,195410,986202,772860,459926,985392,639457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003556s ]