SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801907 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801907 [ RunTime:0.002380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740390,183319,147820,13918,15199,374273,125088,1039552,490628,721453,755277,832402,915507,791418,755146,351688,37056,691666,213973,179303,582179,993898,65298,968173,383541,60705,465487,445659,755891,413488,587474,122633,185291,946599,69260,950393,263957,550306,378375,509880,411380,184812,481915,948883,590794,946010,873356,702914,560284,1033016,238978,289126,352715,643318,849925,460412,624897,190109,927278,824144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]