SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542051 LIMIT 1 [ RunTime:0.000887s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542051 [ RunTime:0.005753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54155,310131,177257,911652,26492,249243,255108,1037884,736859,556044,816711,191248,766195,70224,967770,989758,709125,435458,201075,489176,191964,24885,458144,244250,117210,786707,301169,1018947,361795,535222,14373,473820,127939,110291,848771,881753,453756,449780,29647,155141,353241,912573,1034595,366838,344197,519255,951552,417358,131319,600562,690939,731562,397235,207262,709103,812432,505754,883017,806140,465488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001162s ]