SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567253 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567253 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242806,964671,285037,636412,768776,1000207,252739,822956,96606,805483,369015,1033764,708279,983147,36733,248771,351512,696712,601854,303532,497007,444982,4053,410013,133365,987750,829473,444491,343535,246832,744344,833377,962468,149842,1018953,447211,141353,195549,374813,827143,415798,154098,103809,946283,175834,183298,813157,582553,519442,891243,81347,438801,148977,1038486,847517,328211,861270,670652,346947,838248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]