SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568014 LIMIT 1 [ RunTime:0.001237s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568014 [ RunTime:0.002949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762990,788251,877025,180003,676831,259891,611388,742473,338999,947963,343535,978101,238577,595401,707098,994751,431771,89301,329211,349972,661388,458040,1037042,472152,437302,136839,928843,348990,874769,414999,312219,680307,545380,891660,676865,671979,377137,305056,1042494,17895,271896,186138,533834,946930,235982,527278,322118,507740,961035,770382,877885,671234,985284,715912,581086,243479,273240,981618,436330,886415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003106s ]