SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499220 LIMIT 1 [ RunTime:0.000662s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499220 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535313,577232,940438,432598,731045,167461,598558,359570,120630,94933,581911,381684,374168,816996,255215,660278,596124,400194,830645,1035002,479905,900552,389136,744549,1039134,311596,201698,911584,1009351,441736,591807,857700,480765,230121,938447,658196,625690,889040,151811,994815,911833,165263,228020,553253,122307,1032552,696908,14921,415168,1003562,1026533,753118,296365,859778,271652,784345,124654,940985,250912,761418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]