SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429880 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429880 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526150,312608,373350,363456,676039,990961,727816,762206,15646,644792,481499,139066,275180,435390,949517,301389,112708,391055,410731,660328,731719,401114,675557,529818,561882,48158,843078,271099,429805,489220,96111,379995,89763,698235,643838,158476,455049,386963,568096,472026,538274,1029167,188894,867056,618392,407497,244409,266973,94681,521028,198420,247268,446179,508684,689025,617654,392501,62879,872254,1030963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]