SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507313 LIMIT 1 [ RunTime:0.007156s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507313 [ RunTime:0.005146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859477,359872,25897,819707,187888,698301,345344,985678,3141,559114,1042903,853327,135902,30177,408299,813038,382396,40147,366223,725011,777026,360838,439897,416477,628976,660871,411108,750937,920925,141841,787626,955401,440025,244041,269417,543243,173828,354201,273125,417350,723133,47733,308965,735187,730093,428195,54097,959993,828988,196717,40335,697302,727329,430442,416895,214079,937275,184750,683847,51758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000932s ]