SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486803 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486803 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028979,814101,41543,801920,343559,260211,116817,609730,948017,351682,852043,147656,459992,3714,621384,235023,25217,650104,362918,912289,914588,155960,987945,356950,1032045,349285,359777,1003759,152261,392795,558018,629408,349031,975943,126665,289846,657496,360665,137446,47489,338765,598845,777426,764460,973330,896888,514289,941457,971219,453019,763015,428114,145184,40947,403976,958025,280595,867171,387048,109036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]