SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344098 LIMIT 1 [ RunTime:0.001097s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344098 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858414,619132,570394,868729,1014679,267692,995980,606722,645258,377678,366061,276190,466333,1028577,521207,797237,519100,997017,825038,132415,809968,453876,795957,1027804,647262,111218,514456,940572,876919,568058,969135,943267,672156,136216,855004,410400,432905,718502,360854,450510,899931,26875,300232,220884,404063,202877,965605,325058,694544,1043225,155118,472442,76515,736989,621793,721241,144116,867883,492209,131705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001093s ]