SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310213 LIMIT 1 [ RunTime:0.001535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310213 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585546,663924,589987,574763,66274,119945,996721,495420,714895,438470,12685,56660,478034,19979,332483,671614,944244,725528,761788,640677,349323,903893,8177,229479,143641,31393,591341,233384,429186,251967,608386,601011,736582,553599,76483,471115,704791,664675,868959,840187,915616,753133,832190,58194,509169,655459,247764,817900,737235,158562,891137,470056,863428,20198,794112,1046380,546909,787056,77331,491365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003901s ]