SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412400 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412400 [ RunTime:0.003613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805097,136178,74307,994002,731906,814850,261738,749760,339590,142594,632728,202653,296651,1010813,998335,531279,55977,621624,118952,112425,63476,21885,958972,124349,605955,90521,445735,152420,999814,924824,951151,695067,997645,488685,947566,48075,136337,962383,154793,821238,648157,386040,726401,909746,636138,884995,163754,379413,316261,755587,708700,205417,571591,472613,806691,475221,159674,997386,941771,529293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]