SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534580 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534580 [ RunTime:0.005409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563037,772701,405726,32139,572086,663078,172638,702966,707534,203343,598301,388524,857166,766840,503207,612137,704935,416941,340006,579102,820726,102202,965632,1019429,899526,106192,950533,777530,172854,908600,756134,1026113,172643,732719,806200,771509,752861,997384,359041,11281,405938,241922,586975,996435,106934,874766,122525,199340,772545,487796,203882,49461,717244,240759,821349,801804,102253,689211,532143,737701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]