SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046489 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046489 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180719,525470,323347,569561,1017559,227440,370873,844751,460384,390047,188317,577033,638557,784030,756261,846130,301686,628413,616691,84572,369676,220972,666985,989239,125449,868693,955363,473078,780002,617916,523962,885110,515237,926538,973656,596764,821635,704709,609801,702004,832085,299874,133081,716059,957638,224525,737238,929325,1007592,364030,703194,879735,160352,52670,452833,933697,568133,534712,716423,48028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]