SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412702 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412702 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039261,561385,12100,512686,48910,363811,866001,667969,360895,638934,872486,767261,101616,767042,693005,178639,1032798,1039539,265676,401067,980944,964703,384480,67915,941730,981449,853467,542970,729680,678800,559083,818357,623863,726449,309821,876468,443750,733757,184905,343878,45662,712760,901833,72958,59731,764094,261241,834880,540707,789033,374525,863531,234967,701176,1037901,230919,882607,156511,778976,215042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001415s ]