SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331800 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331800 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989995,1037411,898487,819452,286492,780805,251180,875924,520156,942388,28513,17157,482098,355902,638254,590589,866304,577968,58334,454414,940099,75410,353464,277260,960997,463597,823867,583271,764259,167721,435508,599508,1019245,145366,716055,1006524,684883,864365,35227,147526,822202,890184,81750,109441,273969,169364,867846,353618,154444,352455,38207,280454,752281,1012554,453180,389316,218375,360783,305398,974767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]