SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046601 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046601 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6927,27144,772315,819831,737613,181245,237545,161971,258179,155329,436480,760302,945278,665174,287561,286918,553223,460734,140246,373103,769565,236184,460868,332090,789989,704132,672080,585510,118295,314183,245096,848320,398828,566077,3098,498440,537910,701461,142774,159364,987075,523484,850576,893153,700849,281177,930198,261063,314874,176005,472688,819219,97705,1026795,998928,530790,819308,399064,96846,1021762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]