SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003530s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014216 LIMIT 1 [ RunTime:0.001361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014216 [ RunTime:0.003298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856230,26289,595401,236886,894731,392424,883574,987120,27994,962560,85502,634585,1041401,192330,381229,534295,200270,291275,494816,613412,193198,258986,991184,921647,30213,481087,722860,716879,583020,1036796,377746,125026,408555,4577,398805,29218,46173,561090,400860,649414,4574,344713,303163,280296,860567,1016886,251945,943247,798592,173478,142311,1026837,89190,621681,457713,845450,785142,96443,802716,530331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001390s ]