SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019195 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019195 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850701,555813,1012935,13018,454503,615136,864748,69923,587389,377303,134802,202715,243299,87420,649344,824948,120118,699158,954115,681849,221531,506802,126910,504121,230721,358376,470090,525826,547989,153285,30513,216388,133570,602062,85500,801829,1038347,259931,895821,11106,662310,221415,94465,642416,912883,579599,969332,368793,946239,991512,829485,933973,154773,879681,402307,117472,385679,370599,320051,696093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000984s ]