SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200856 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200856 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35610,63722,225931,906769,805190,54354,359238,194152,191418,588490,372380,672229,928203,89738,723738,454923,787060,503267,125070,162944,704252,860199,709504,329012,251350,999928,373793,1006671,888450,455165,74229,879119,985329,198924,684779,491650,831621,465997,17119,739269,828167,603008,490880,939621,136681,405161,94223,236257,35490,960067,758134,365047,446876,237322,336631,685090,448642,241326,331264,477230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001264s ]