SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504291 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504291 [ RunTime:0.002850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408099,29619,113066,412463,392800,294098,449379,439738,330214,989444,869280,443613,539605,341640,342982,29843,152104,535313,540137,84914,657655,696803,656420,318542,926220,58589,829339,82659,633954,161110,910936,628764,476560,169625,716568,504276,572846,399952,899565,929831,842510,752212,298092,645203,242700,37351,937970,272264,513905,749147,441177,689007,848167,43369,883500,302765,1287,636506,89797,9057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]