SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410693 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410693 [ RunTime:0.003805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540328,478212,993564,71603,433271,825421,762764,715396,776124,761436,37480,872192,963290,475386,144464,38847,426692,287309,1004278,1045014,189281,547566,203680,699836,46846,391822,378342,518410,182362,442641,1017975,179505,511571,446514,143954,626031,623793,397919,952855,1006547,606833,366689,808276,685108,774179,356960,909825,201235,503891,637345,1001981,190336,73507,512678,993558,107459,515880,216615,239391,100777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]