SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304508 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304508 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325008,152766,533756,616967,467665,56212,789389,62540,908580,166737,300353,386161,370496,145924,969314,694131,671083,143942,632665,893403,984057,728580,528952,452173,517965,426041,655559,635799,808080,243868,1037371,915815,173271,629729,330864,818272,155721,802408,674926,56848,682995,620239,946988,34238,117191,188684,891703,150587,721949,477152,863409,1041298,536156,761555,61296,512007,531365,328187,1035779,839073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000964s ]