SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504787 LIMIT 1 [ RunTime:0.000774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504787 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126166,656366,332714,56950,986700,532009,656706,349654,777040,225077,109323,112544,1030349,434313,536100,105074,956121,15003,12591,8803,506993,1005470,160663,493104,769323,929966,33678,772448,901989,582005,726268,649151,29525,974783,425604,963261,33321,323972,412415,153205,150682,90921,899482,84528,791044,1007980,675407,221527,49114,1037028,891199,768911,330030,184997,694550,688816,49889,1012572,951414,697744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000792s ]