SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403705 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403705 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651309,214770,1034015,666264,998891,911021,588366,52521,680816,763913,779088,975943,36837,15134,61245,132800,584791,888408,205386,426449,481412,334881,577282,446097,82955,13223,688239,731141,761653,822871,166902,856553,399575,112621,818339,169048,202433,169941,31514,161292,395950,33949,569051,647087,674668,691775,51112,8267,66701,537080,590858,557496,187046,474419,970192,298215,976568,524176,295110,321730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]