SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438346 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438346 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117529,396041,697959,300227,938143,655102,237064,481788,475470,712219,962723,688403,949960,134401,89897,157083,678720,814734,382197,1034173,138234,572195,876076,627437,178513,209639,508847,695566,378518,848280,470797,650847,176933,615428,466309,717180,564033,817084,785410,470441,844075,163597,390187,300016,1017538,116766,847654,683669,333545,48368,493764,456660,28678,909435,417658,760682,748237,102102,549214,546690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]