SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308628 LIMIT 1 [ RunTime:0.002666s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308628 [ RunTime:0.003743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640843,1040559,605046,179579,227299,995217,366129,598749,487301,352658,597802,715265,412648,377067,527707,724229,714780,167901,564702,109150,76672,306659,801677,776631,291056,917703,297806,592037,515332,308618,610044,650749,162259,91628,855461,599593,754747,2826,33137,407571,570809,263150,923647,727352,54279,13174,281763,538935,225497,449335,114877,827769,691737,1023539,352643,177082,516168,17671,370458,273402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]