SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489814 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489814 [ RunTime:0.002283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913774,232846,679917,837049,654918,385045,485285,232741,1008172,1046555,297136,309258,327052,863655,396994,319937,880774,656400,757813,561154,380180,677203,942052,49858,538321,885325,933383,350419,394480,20469,216306,1046015,623199,737026,357505,761170,723426,910906,956800,497709,112251,911991,900525,163133,654318,123455,229675,926203,414645,751730,82909,332998,999960,278311,119454,417927,238961,856677,473157,372861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]