SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441993 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441993 [ RunTime:0.004422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508465,45577,228891,153704,632761,390592,468590,216956,630878,493599,46766,853277,293304,194485,64008,411744,90082,405995,742195,738242,302740,187905,346926,119250,636158,617878,277395,435364,946695,577191,28906,359306,1028489,434088,656583,974141,563071,988822,560781,357174,199715,674597,547896,950407,727435,202201,646808,682268,943232,623858,272170,798253,22637,157628,356990,447687,799799,982412,351258,282801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]