SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506300 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506300 [ RunTime:0.002145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798751,585754,968730,894782,986529,1011364,914862,677558,673284,744876,607968,295364,339941,692057,729977,957772,554191,916685,411825,560408,362695,455213,499487,442919,729690,705568,176365,252383,628914,643448,660944,683346,891336,218714,471455,730572,712868,633099,658167,186400,378010,695431,900908,48708,218826,750007,468578,960030,948056,45090,313936,115985,93947,1011269,83430,288010,864446,676992,83940,11380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001197s ]