SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409540 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409540 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763229,614373,314215,26508,721247,424729,450303,253272,724831,729034,324897,548525,259809,655610,88677,733894,213749,990750,166347,439394,496417,240797,745790,165079,893414,826599,218482,758419,348657,579766,851294,1030621,459931,470277,784574,1030969,279353,593261,730309,180657,267838,728460,501650,3386,279497,731446,927598,203222,536830,176271,422114,132950,18136,165895,382498,35836,389107,461292,69802,1027630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]