SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503308 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503308 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701616,707034,1037487,102457,721889,276221,916910,312759,203776,797337,709924,386755,794754,8503,185203,217746,667506,739805,308148,638875,687756,605402,185668,169693,762532,744467,165991,940180,692972,703146,806375,666331,180564,624524,223900,961020,279460,198499,968419,712728,756375,418240,558059,993936,319978,614781,297970,769272,108049,850562,86603,442983,425769,690246,507918,556913,491902,115832,257132,966798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]