SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502820 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502820 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762092,173967,672897,1024666,148539,890499,331946,417241,597349,886328,274003,167598,907017,488638,1041330,517936,681989,61913,559486,859206,130355,662691,544978,622252,492398,500238,795084,616976,158584,454195,97254,858140,782545,660070,506638,41125,689198,287515,409759,328946,396489,296090,720130,99245,242779,783155,784752,472046,418930,855342,723457,978363,5894,63492,581779,404114,894716,478700,667028,1026386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]