SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543083 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543083 [ RunTime:0.003985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000650,709546,213659,449658,292578,443039,351917,1044133,940541,660859,1032766,632491,31523,562414,777126,626915,66767,965979,140103,724154,56478,760384,958248,556581,251858,912800,708692,485116,466208,95474,647135,516798,970743,485609,81457,496182,50403,688394,208691,863044,684448,751442,911254,815351,852188,527468,771224,364438,860659,664600,527242,568434,13938,542122,276365,309890,360748,128591,828815,730521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]