SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492843 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492843 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784133,800131,685070,752407,585458,199456,589289,969742,396670,204840,405960,774332,172127,571987,690938,24469,653363,1037147,567732,317389,454494,192388,725966,874356,31323,600202,504512,1043122,882346,946890,1044856,298034,346912,913684,779328,23421,355826,347996,67501,720942,875516,741427,798114,225314,436170,335443,147102,1001030,192796,965174,417308,670141,963592,586092,1329,429247,312859,477078,61006,358776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]