SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468376 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468376 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400268,1030631,728129,787887,350624,108124,345569,452974,137447,1032467,838854,462149,108569,875002,278001,492244,36156,130437,865760,348261,763019,134889,621972,330546,962893,585526,728653,570572,627499,386768,458960,73408,943658,61450,223771,258809,1035924,499744,661769,949017,304939,259550,846382,96390,509371,350714,579857,916128,479259,252929,656616,822493,27377,302855,117956,50426,420592,665919,939339,730086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]