SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548417 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548417 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168761,726973,310842,71155,369562,719065,201414,909814,697662,218453,674770,438685,346345,441059,552388,251202,974498,426601,443246,390387,156032,416462,368437,828990,629670,534134,58363,736931,380171,348890,498684,514501,594670,1045454,219192,207577,638262,575971,184160,958242,96587,374938,23435,293239,946629,398889,628706,536614,135142,899882,541411,689236,456381,133116,1019507,583458,408063,942141,926993,380258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001449s ]