SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302928 LIMIT 1 [ RunTime:0.000898s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302928 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302137,670382,379815,537056,134009,551396,872295,1034144,588610,770779,253269,149867,939320,189538,761960,523023,961958,726908,771569,755608,647611,556808,734251,421372,598781,639542,204176,419365,772372,797313,546197,547953,904122,267743,70506,589173,356971,650052,574888,1040194,814791,188127,893409,547223,368420,805114,472790,658857,104485,205215,37422,19790,416214,146902,959320,159512,247985,734001,508152,46552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]