SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5411 LIMIT 1 [ RunTime:0.001150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5411 [ RunTime:0.002983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113496,578873,270462,252384,455351,201804,440684,295468,242612,272924,1008257,732423,411059,838375,418665,67388,479578,136301,532805,197560,1002666,673829,52105,667301,343980,624184,831146,646803,343233,200838,904145,712623,859766,650465,813821,611295,1014494,484103,505871,325632,635719,423858,53426,901347,486700,109598,578496,503126,474266,53771,533320,313773,167971,723365,973638,483924,1001301,729842,906352,23466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]