SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016220 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016220 [ RunTime:0.003787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047729,248863,744076,241286,446667,905949,34280,851941,348515,160914,16713,807908,1042372,884811,84287,189615,955333,787880,517892,505472,813080,136092,509256,99366,296603,294762,426474,919273,286620,876112,764723,645650,912967,505177,609648,588183,490392,539301,809848,622812,915457,853725,810378,582486,351509,24452,105710,32990,431507,654535,603012,599819,790628,831090,915821,831276,453142,924749,137240,607016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001867s ]