SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309980 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309980 [ RunTime:0.005998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327594,617920,443504,314246,880532,989556,998544,408229,558187,39129,945461,544989,556225,917497,668741,1007702,484755,543048,775469,1015174,21478,353335,175419,834897,946117,673541,491687,419350,261732,41442,771472,108608,295298,851355,805863,475968,838353,661589,284475,314129,462044,645422,846071,640345,676536,727438,201077,931063,523452,750910,468197,744355,838692,140605,277691,396396,445646,743703,167804,906844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001505s ]