SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489408 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489408 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425055,513523,568513,987055,133332,592151,449501,152820,180390,518563,253729,235143,534646,301230,395266,196933,83518,380543,959367,476159,864805,127489,992968,121819,619622,407946,95791,622009,37028,433403,639151,95095,208408,193997,466377,756117,417100,769031,112134,1037406,147293,363726,215232,534581,467092,237080,438033,182044,677441,956318,947564,772233,661865,499159,795662,659166,708059,710718,437016,575726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]