SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024711 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024711 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411612,790850,194318,362651,988339,450070,596137,992096,566033,499091,563590,821689,527594,407487,473139,227694,199305,778225,341432,960818,82045,246496,958770,210275,848007,456437,975246,192648,149575,273169,688119,1035892,523066,562179,283644,804167,299682,943153,897671,146284,710021,650113,461445,635703,740877,413508,818227,112808,43836,680288,750504,873906,160643,389164,662464,773646,981003,539303,553597,179774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]