SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193903 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193903 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563490,903464,982579,726521,619115,483012,352764,393219,603344,300882,825580,484158,178587,984147,197618,899209,147647,762582,135772,683233,193723,585006,525205,822042,893665,872281,200419,110161,117461,767064,1047758,305465,1026834,385539,474882,666051,467397,457575,880707,779541,337248,938849,437160,287688,615196,195488,774440,460682,888019,733817,1019977,695187,188262,674698,848627,899578,624304,194596,574636,959288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]