SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550844 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550844 [ RunTime:0.002142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833478,710723,775554,63155,477638,963584,772985,220543,250897,892318,519526,22172,311028,446628,84810,80910,723914,417962,198473,312676,954846,124453,111632,501210,532213,337402,827445,775184,699371,360002,65394,741004,485158,979507,366073,304911,552601,468217,376741,334329,374773,11935,172328,675360,890670,311095,803666,750072,779524,412381,138842,527304,933447,880229,704858,407338,145562,183946,70100,133896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]