SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50761 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50761 [ RunTime:0.006870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981469,517177,191620,193011,79136,336829,118359,530714,953855,958402,657462,829855,441694,937423,587935,1030948,859143,751904,284399,280755,163649,900891,488973,1039594,977482,21593,459524,214687,621902,310209,437529,169368,312722,374590,764413,381402,1041129,536026,273563,845777,810407,366419,534672,946289,125273,199893,508109,42201,496480,501945,77355,461564,645766,934902,251245,433656,439519,890655,890113,960182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]